<%@page import="java.sql.*, fachada.*, imagem.*;"%>
<html>
<head>
<title>jsp1</title>
</head>
<body bgcolor="#ffffff">
<!-- table width="781" border="2">
<tr>
<td width="83" bgcolor="#C0C0C0">
<b>Codigo</b>
</td>
<td width="228" bgcolor="#C0C0C0">
<b>Foto</b>
</td>
</tr-->
<%
Connection conn = null;
Statement stmt = null;
ResultSet rset = null;
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","sa");
stmt = conn.createStatement();
rset = stmt.executeQuery("select codigo,video from tb_video_comercial"); 

while (rset.next()) {
%>
<!-- tr>
<td width="83">

</td>
</tr-->
</table>

<center>
<div style="float:left; width:33%">
<table><tr><td>
	<object type="application/x-shockwave-flash" data="player_mp3_mini.swf" width="200" height="20">
	<param name="movie" value="player_mp3_mini.swf" />
	<param name="bgcolor" value="000000"/>
    <param name="FlashVars" value="getImage.jsp?cod="<%=rset.getInt("codigo")%> /> </object>
	
	
	</td>
	</tr>
	<!-- tr><td align="center">< %=rset.getObject("cod")%></td></tr -->
</table>
</div>

</center>

<%
}
conn.close();
%>

</body>
</html> 